{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sys import path\n",
    "path.append(r\"D:\\\\SmartCloudFuture\")\n",
    "\n",
    "from SCTK import scada"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "module 'SCTK.scada' has no attribute 'algo_module'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-17-0eaa7dc9612e>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mscada\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0malgo_module\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: module 'SCTK.scada' has no attribute 'algo_module'"
     ]
    }
   ],
   "source": [
    "scada.algo_module"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "get_pe_ttm('600570', '20170606')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from pymongo import MongoClient\n",
    "\n",
    "conn = MongoClient('127.0.0.1', 27017)\n",
    "db = conn.stockdata\n",
    "incomedb = db['income']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = incomedb.find({\"code\":\"600570.XSHG\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.DataFrame(list(result))  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>administration_expense</th>\n",
       "      <th>asset_impairment_loss</th>\n",
       "      <th>basic_eps</th>\n",
       "      <th>ci_minority_owners</th>\n",
       "      <th>ci_parent_company_owners</th>\n",
       "      <th>code</th>\n",
       "      <th>commission_expense</th>\n",
       "      <th>commission_income</th>\n",
       "      <th>diluted_eps</th>\n",
       "      <th>...</th>\n",
       "      <th>refunded_premiums</th>\n",
       "      <th>reinsurance_cost</th>\n",
       "      <th>sale_expense</th>\n",
       "      <th>statDate</th>\n",
       "      <th>statDate_1</th>\n",
       "      <th>total_composite_income</th>\n",
       "      <th>total_operating_cost</th>\n",
       "      <th>total_operating_revenue</th>\n",
       "      <th>total_profit</th>\n",
       "      <th>withdraw_insurance_contract_reserve</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5ac57fb02e565406381d089f</td>\n",
       "      <td>1.650519e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.326427e+06</td>\n",
       "      <td>2005-03-31</td>\n",
       "      <td>2005-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.169257e+07</td>\n",
       "      <td>3.861545e+07</td>\n",
       "      <td>2.471650e+05</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5ac57fb02e565406381d08a0</td>\n",
       "      <td>1.350073e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.026373e+06</td>\n",
       "      <td>2005-06-30</td>\n",
       "      <td>2005-06-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.834777e+07</td>\n",
       "      <td>4.962814e+07</td>\n",
       "      <td>2.502735e+06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5ac57fb02e565406381d08a1</td>\n",
       "      <td>1.633236e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.478560e+07</td>\n",
       "      <td>2005-09-30</td>\n",
       "      <td>2005-09-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.395177e+07</td>\n",
       "      <td>4.878073e+07</td>\n",
       "      <td>-1.067038e+06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5ac57fb02e565406381d08a2</td>\n",
       "      <td>3.588122e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.260748e+07</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.805474e+07</td>\n",
       "      <td>9.971500e+07</td>\n",
       "      <td>6.309092e+06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5ac57fb02e565406381d08a3</td>\n",
       "      <td>1.118624e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0191</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0137</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.395958e+07</td>\n",
       "      <td>2006-03-31</td>\n",
       "      <td>2006-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.949652e+07</td>\n",
       "      <td>5.551059e+07</td>\n",
       "      <td>1.853099e+06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5ac57fb02e565406381d08a4</td>\n",
       "      <td>2.365025e+07</td>\n",
       "      <td>2.546915e+06</td>\n",
       "      <td>0.0209</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0163</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.147031e+07</td>\n",
       "      <td>2006-06-30</td>\n",
       "      <td>2006-06-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.285141e+07</td>\n",
       "      <td>8.146291e+07</td>\n",
       "      <td>4.676409e+06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5ac57fb02e565406381d08a5</td>\n",
       "      <td>1.898346e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.548291e+07</td>\n",
       "      <td>2006-09-30</td>\n",
       "      <td>2006-09-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.755671e+07</td>\n",
       "      <td>7.771690e+07</td>\n",
       "      <td>1.415241e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5ac57fb02e565406381d08a6</td>\n",
       "      <td>3.815899e+07</td>\n",
       "      <td>6.656682e+06</td>\n",
       "      <td>0.1600</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1900</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.319190e+07</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.306259e+08</td>\n",
       "      <td>1.311665e+08</td>\n",
       "      <td>4.150465e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5ac57fb02e565406381d08a7</td>\n",
       "      <td>1.675826e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0922</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0922</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.401888e+07</td>\n",
       "      <td>2007-03-31</td>\n",
       "      <td>2007-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.596684e+07</td>\n",
       "      <td>5.925009e+07</td>\n",
       "      <td>1.602855e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5ac57fb02e565406381d08a8</td>\n",
       "      <td>2.306086e+07</td>\n",
       "      <td>2.645505e+06</td>\n",
       "      <td>0.1078</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1078</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.458784e+07</td>\n",
       "      <td>2007-06-30</td>\n",
       "      <td>2007-06-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.200182e+08</td>\n",
       "      <td>1.255172e+08</td>\n",
       "      <td>2.988806e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5ac57fb02e565406381d08a9</td>\n",
       "      <td>2.969795e+07</td>\n",
       "      <td>3.810000e+04</td>\n",
       "      <td>0.2200</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2200</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.070183e+07</td>\n",
       "      <td>2007-09-30</td>\n",
       "      <td>2007-09-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.322278e+08</td>\n",
       "      <td>1.561338e+08</td>\n",
       "      <td>4.894864e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5ac57fb02e565406381d08aa</td>\n",
       "      <td>7.705690e+07</td>\n",
       "      <td>2.057964e+06</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.246804e+07</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.067672e+08</td>\n",
       "      <td>2.315271e+08</td>\n",
       "      <td>4.705567e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5ac57fb02e565406381d08ab</td>\n",
       "      <td>3.024180e+07</td>\n",
       "      <td>3.510349e+05</td>\n",
       "      <td>0.1300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1300</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.163227e+07</td>\n",
       "      <td>2008-03-31</td>\n",
       "      <td>2008-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.245168e+08</td>\n",
       "      <td>1.495216e+08</td>\n",
       "      <td>2.801362e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5ac57fb02e565406381d08ac</td>\n",
       "      <td>3.006031e+07</td>\n",
       "      <td>1.403876e+06</td>\n",
       "      <td>0.0300</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0300</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.227069e+07</td>\n",
       "      <td>2008-06-30</td>\n",
       "      <td>2008-06-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.731574e+07</td>\n",
       "      <td>1.115232e+08</td>\n",
       "      <td>7.551398e+06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5ac57fb02e565406381d08ad</td>\n",
       "      <td>3.841346e+07</td>\n",
       "      <td>1.764896e+05</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.389238e+07</td>\n",
       "      <td>2008-09-30</td>\n",
       "      <td>2008-09-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.168202e+08</td>\n",
       "      <td>1.430293e+08</td>\n",
       "      <td>3.502918e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5ac57fb02e565406381d08ae</td>\n",
       "      <td>1.015926e+08</td>\n",
       "      <td>-1.732956e+06</td>\n",
       "      <td>0.1800</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1800</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.590820e+07</td>\n",
       "      <td>2008-12-31</td>\n",
       "      <td>2008-12-31</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.188555e+08</td>\n",
       "      <td>2.646075e+08</td>\n",
       "      <td>6.589000e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5ac57fb02e565406381d08af</td>\n",
       "      <td>2.597913e+07</td>\n",
       "      <td>1.073165e+06</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.219355e+07</td>\n",
       "      <td>2009-03-31</td>\n",
       "      <td>2009-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.012803e+08</td>\n",
       "      <td>1.195908e+08</td>\n",
       "      <td>3.628342e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5ac57fb02e565406381d08b0</td>\n",
       "      <td>3.680308e+07</td>\n",
       "      <td>1.913249e+06</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.033340e+07</td>\n",
       "      <td>2009-06-30</td>\n",
       "      <td>2009-06-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.680222e+07</td>\n",
       "      <td>1.298877e+08</td>\n",
       "      <td>4.342704e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5ac57fb02e565406381d08b1</td>\n",
       "      <td>4.002534e+07</td>\n",
       "      <td>-3.398468e+05</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.711301e+07</td>\n",
       "      <td>2009-09-30</td>\n",
       "      <td>2009-09-30</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.142544e+08</td>\n",
       "      <td>1.570479e+08</td>\n",
       "      <td>5.920321e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5ac57fb02e565406381d08b2</td>\n",
       "      <td>1.121848e+08</td>\n",
       "      <td>5.899604e+04</td>\n",
       "      <td>0.1800</td>\n",
       "      <td>4.360651e+06</td>\n",
       "      <td>2.066964e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1800</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.158045e+07</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>2009-12-31</td>\n",
       "      <td>2.110571e+08</td>\n",
       "      <td>2.692821e+08</td>\n",
       "      <td>3.231854e+08</td>\n",
       "      <td>9.376719e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5ac57fb02e565406381d08b3</td>\n",
       "      <td>4.459986e+07</td>\n",
       "      <td>3.102105e+04</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>-1.496884e+06</td>\n",
       "      <td>3.479874e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.535861e+07</td>\n",
       "      <td>2010-03-31</td>\n",
       "      <td>2010-03-31</td>\n",
       "      <td>3.330186e+07</td>\n",
       "      <td>8.620820e+07</td>\n",
       "      <td>1.079588e+08</td>\n",
       "      <td>3.632138e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5ac57fb02e565406381d08b4</td>\n",
       "      <td>5.693299e+07</td>\n",
       "      <td>3.165044e+06</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>1.576848e+06</td>\n",
       "      <td>4.151714e+06</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.531866e+07</td>\n",
       "      <td>2010-06-30</td>\n",
       "      <td>2010-06-30</td>\n",
       "      <td>5.728562e+06</td>\n",
       "      <td>1.663644e+08</td>\n",
       "      <td>1.868096e+08</td>\n",
       "      <td>2.387972e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5ac57fb02e565406381d08b5</td>\n",
       "      <td>6.523471e+07</td>\n",
       "      <td>-6.996882e+04</td>\n",
       "      <td>0.1072</td>\n",
       "      <td>2.383394e+06</td>\n",
       "      <td>7.635227e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1072</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.192449e+07</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>7.873566e+07</td>\n",
       "      <td>1.568459e+08</td>\n",
       "      <td>2.151671e+08</td>\n",
       "      <td>7.504538e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5ac57fb02e565406381d08b6</td>\n",
       "      <td>1.592635e+08</td>\n",
       "      <td>9.688032e+05</td>\n",
       "      <td>0.1565</td>\n",
       "      <td>5.484606e+05</td>\n",
       "      <td>1.043264e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1565</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.173393e+07</td>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>2010-12-31</td>\n",
       "      <td>1.048749e+08</td>\n",
       "      <td>3.096945e+08</td>\n",
       "      <td>3.572915e+08</td>\n",
       "      <td>1.084017e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5ac57fb02e565406381d08b7</td>\n",
       "      <td>6.092596e+07</td>\n",
       "      <td>1.847453e+04</td>\n",
       "      <td>0.0655</td>\n",
       "      <td>-3.274922e+05</td>\n",
       "      <td>4.070879e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0655</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.878803e+07</td>\n",
       "      <td>2011-03-31</td>\n",
       "      <td>2011-03-31</td>\n",
       "      <td>4.038130e+07</td>\n",
       "      <td>1.281578e+08</td>\n",
       "      <td>1.596664e+08</td>\n",
       "      <td>4.334764e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5ac57fb02e565406381d08b8</td>\n",
       "      <td>8.860041e+07</td>\n",
       "      <td>4.674910e+06</td>\n",
       "      <td>0.0450</td>\n",
       "      <td>3.082941e+06</td>\n",
       "      <td>1.939936e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0450</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.323484e+07</td>\n",
       "      <td>2011-06-30</td>\n",
       "      <td>2011-06-30</td>\n",
       "      <td>2.248230e+07</td>\n",
       "      <td>1.951570e+08</td>\n",
       "      <td>2.100290e+08</td>\n",
       "      <td>3.541586e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5ac57fb02e565406381d08b9</td>\n",
       "      <td>9.171340e+07</td>\n",
       "      <td>6.000000e+03</td>\n",
       "      <td>0.0605</td>\n",
       "      <td>-1.931755e+06</td>\n",
       "      <td>3.853734e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0605</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.146168e+07</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>3.660559e+07</td>\n",
       "      <td>1.645998e+08</td>\n",
       "      <td>1.878616e+08</td>\n",
       "      <td>3.582275e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5ac57fb02e565406381d08ba</td>\n",
       "      <td>1.801892e+08</td>\n",
       "      <td>3.616142e+06</td>\n",
       "      <td>0.2390</td>\n",
       "      <td>5.365554e+06</td>\n",
       "      <td>1.706327e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2390</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.084292e+07</td>\n",
       "      <td>2011-12-31</td>\n",
       "      <td>2011-12-31</td>\n",
       "      <td>1.759983e+08</td>\n",
       "      <td>3.706134e+08</td>\n",
       "      <td>4.906363e+08</td>\n",
       "      <td>1.712592e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5ac57fb02e565406381d08bb</td>\n",
       "      <td>8.269467e+07</td>\n",
       "      <td>-4.464517e+05</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>5.112116e+05</td>\n",
       "      <td>1.767486e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.160459e+07</td>\n",
       "      <td>2012-03-31</td>\n",
       "      <td>2012-03-31</td>\n",
       "      <td>1.818607e+07</td>\n",
       "      <td>1.354821e+08</td>\n",
       "      <td>1.422648e+08</td>\n",
       "      <td>3.418722e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5ac57fb02e565406381d08bc</td>\n",
       "      <td>1.136536e+08</td>\n",
       "      <td>7.355792e+06</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>-4.523277e+05</td>\n",
       "      <td>2.180667e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.086143e+07</td>\n",
       "      <td>2012-06-30</td>\n",
       "      <td>2012-06-30</td>\n",
       "      <td>2.135434e+07</td>\n",
       "      <td>2.097509e+08</td>\n",
       "      <td>2.156263e+08</td>\n",
       "      <td>3.390782e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>5ac57fb02e565406381d08bd</td>\n",
       "      <td>1.157561e+08</td>\n",
       "      <td>1.332350e+03</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>1.847703e+06</td>\n",
       "      <td>4.054506e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0500</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.373194e+07</td>\n",
       "      <td>2012-09-30</td>\n",
       "      <td>2012-09-30</td>\n",
       "      <td>4.239276e+07</td>\n",
       "      <td>1.992396e+08</td>\n",
       "      <td>1.961722e+08</td>\n",
       "      <td>2.989635e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>5ac57fb02e565406381d08be</td>\n",
       "      <td>1.941328e+08</td>\n",
       "      <td>2.278108e+06</td>\n",
       "      <td>0.1800</td>\n",
       "      <td>1.005796e+07</td>\n",
       "      <td>7.868710e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1800</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.416365e+07</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>8.874506e+07</td>\n",
       "      <td>4.068516e+08</td>\n",
       "      <td>4.520283e+08</td>\n",
       "      <td>1.232218e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>5ac57fb02e565406381d08bf</td>\n",
       "      <td>9.848443e+07</td>\n",
       "      <td>-9.510166e+06</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>-2.325110e+06</td>\n",
       "      <td>6.354569e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.219553e+07</td>\n",
       "      <td>2013-03-31</td>\n",
       "      <td>2013-03-31</td>\n",
       "      <td>6.122058e+07</td>\n",
       "      <td>1.498439e+08</td>\n",
       "      <td>1.719325e+08</td>\n",
       "      <td>4.043195e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>5ac57fb02e565406381d08c0</td>\n",
       "      <td>1.168314e+08</td>\n",
       "      <td>4.447159e+06</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>2.047870e+05</td>\n",
       "      <td>4.849819e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.393863e+07</td>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>4.870298e+07</td>\n",
       "      <td>2.283300e+08</td>\n",
       "      <td>2.493508e+08</td>\n",
       "      <td>4.934582e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>5ac57fb02e565406381d08c1</td>\n",
       "      <td>1.226154e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>3.124965e+05</td>\n",
       "      <td>5.286367e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.850965e+07</td>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>5.317617e+07</td>\n",
       "      <td>2.002277e+08</td>\n",
       "      <td>2.244718e+08</td>\n",
       "      <td>7.485840e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>5ac57fb02e565406381d08c2</td>\n",
       "      <td>2.351538e+08</td>\n",
       "      <td>-1.121188e+06</td>\n",
       "      <td>0.3100</td>\n",
       "      <td>1.793916e+07</td>\n",
       "      <td>1.952787e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3100</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.758727e+07</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>2.132179e+08</td>\n",
       "      <td>4.482614e+08</td>\n",
       "      <td>5.647921e+08</td>\n",
       "      <td>2.035822e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>5ac57fb02e565406381d08c3</td>\n",
       "      <td>1.257998e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>-2.786795e+06</td>\n",
       "      <td>6.297603e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.733678e+07</td>\n",
       "      <td>2014-03-31</td>\n",
       "      <td>2014-03-31</td>\n",
       "      <td>6.018924e+07</td>\n",
       "      <td>1.884408e+08</td>\n",
       "      <td>2.017034e+08</td>\n",
       "      <td>5.921796e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>5ac57fb02e565406381d08c4</td>\n",
       "      <td>1.516363e+08</td>\n",
       "      <td>5.117408e+06</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>-2.213100e+06</td>\n",
       "      <td>4.176991e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.525140e+07</td>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>3.955681e+07</td>\n",
       "      <td>2.521245e+08</td>\n",
       "      <td>2.609672e+08</td>\n",
       "      <td>5.877667e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>5ac57fb02e565406381d08c5</td>\n",
       "      <td>1.883604e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0300</td>\n",
       "      <td>2.812352e+06</td>\n",
       "      <td>4.999361e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0300</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.047286e+08</td>\n",
       "      <td>2014-09-30</td>\n",
       "      <td>2014-09-30</td>\n",
       "      <td>5.280596e+07</td>\n",
       "      <td>3.189146e+08</td>\n",
       "      <td>3.082180e+08</td>\n",
       "      <td>5.096428e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5ac57fb02e565406381d08c6</td>\n",
       "      <td>3.352965e+08</td>\n",
       "      <td>7.862399e+04</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>-3.980238e+06</td>\n",
       "      <td>2.183323e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.401018e+08</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>2.143521e+08</td>\n",
       "      <td>5.050815e+08</td>\n",
       "      <td>6.509505e+08</td>\n",
       "      <td>2.171650e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>5ac57fb02e565406381d08c7</td>\n",
       "      <td>1.584945e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>1.429527e+06</td>\n",
       "      <td>1.135436e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.756997e+07</td>\n",
       "      <td>2015-03-31</td>\n",
       "      <td>2015-03-31</td>\n",
       "      <td>1.149732e+08</td>\n",
       "      <td>2.648900e+08</td>\n",
       "      <td>2.741318e+08</td>\n",
       "      <td>7.809997e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>5ac57fb02e565406381d08c8</td>\n",
       "      <td>2.800698e+08</td>\n",
       "      <td>8.130811e+06</td>\n",
       "      <td>0.2300</td>\n",
       "      <td>2.183161e+07</td>\n",
       "      <td>1.771184e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2300</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.511712e+08</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>1.989500e+08</td>\n",
       "      <td>5.242981e+08</td>\n",
       "      <td>6.342701e+08</td>\n",
       "      <td>1.753289e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>5ac57fb02e565406381d08c9</td>\n",
       "      <td>3.721475e+08</td>\n",
       "      <td>-6.018500e+05</td>\n",
       "      <td>-0.0800</td>\n",
       "      <td>-5.895487e+07</td>\n",
       "      <td>-8.562011e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0800</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.667889e+08</td>\n",
       "      <td>2015-09-30</td>\n",
       "      <td>2015-09-30</td>\n",
       "      <td>-1.445750e+08</td>\n",
       "      <td>5.540822e+08</td>\n",
       "      <td>3.899162e+08</td>\n",
       "      <td>-1.033324e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>5ac57fb02e565406381d08ca</td>\n",
       "      <td>2.468927e+08</td>\n",
       "      <td>1.164646e+08</td>\n",
       "      <td>0.4700</td>\n",
       "      <td>3.123601e+07</td>\n",
       "      <td>3.495755e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4700</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.762892e+08</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>3.808116e+08</td>\n",
       "      <td>6.161181e+08</td>\n",
       "      <td>9.272142e+08</td>\n",
       "      <td>3.650838e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>5ac57fb02e565406381d08cb</td>\n",
       "      <td>2.026724e+08</td>\n",
       "      <td>-2.479232e+04</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>-7.001210e+06</td>\n",
       "      <td>3.477532e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.163337e+08</td>\n",
       "      <td>2016-03-31</td>\n",
       "      <td>2016-03-31</td>\n",
       "      <td>2.777411e+07</td>\n",
       "      <td>3.293775e+08</td>\n",
       "      <td>3.369861e+08</td>\n",
       "      <td>7.014102e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>5ac57fb02e565406381d08cc</td>\n",
       "      <td>2.976088e+08</td>\n",
       "      <td>2.151423e+06</td>\n",
       "      <td>0.1500</td>\n",
       "      <td>-1.178011e+07</td>\n",
       "      <td>1.002529e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1500</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.279108e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>8.847283e+07</td>\n",
       "      <td>4.608934e+08</td>\n",
       "      <td>4.835933e+08</td>\n",
       "      <td>8.928306e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>5ac57fb02e565406381d08cd</td>\n",
       "      <td>3.298132e+08</td>\n",
       "      <td>-1.092348e+05</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>5.691626e+06</td>\n",
       "      <td>4.382338e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.008967e+08</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>4.951500e+07</td>\n",
       "      <td>5.665901e+08</td>\n",
       "      <td>5.168427e+08</td>\n",
       "      <td>2.343213e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>5ac57fb02e565406381d08ce</td>\n",
       "      <td>5.047452e+08</td>\n",
       "      <td>2.120523e+06</td>\n",
       "      <td>-0.3000</td>\n",
       "      <td>-5.661848e+07</td>\n",
       "      <td>-1.610010e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.3000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.178740e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>-2.176195e+08</td>\n",
       "      <td>7.849189e+08</td>\n",
       "      <td>8.327441e+08</td>\n",
       "      <td>-2.428427e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>5ac57fb02e565406381d08cf</td>\n",
       "      <td>2.971846e+08</td>\n",
       "      <td>-1.289054e+06</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>-1.193785e+06</td>\n",
       "      <td>7.429376e+07</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.580180e+08</td>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>7.309998e+07</td>\n",
       "      <td>4.778144e+08</td>\n",
       "      <td>4.428547e+08</td>\n",
       "      <td>4.108078e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>5ac57fb02e565406381d08d0</td>\n",
       "      <td>3.598160e+08</td>\n",
       "      <td>1.326131e+07</td>\n",
       "      <td>0.3000</td>\n",
       "      <td>5.240964e+06</td>\n",
       "      <td>1.782194e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.869998e+08</td>\n",
       "      <td>2017-06-30</td>\n",
       "      <td>2017-06-30</td>\n",
       "      <td>1.834603e+08</td>\n",
       "      <td>5.923973e+08</td>\n",
       "      <td>6.374332e+08</td>\n",
       "      <td>2.054813e+08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>5ac57fb02e565406381d08d1</td>\n",
       "      <td>4.150214e+08</td>\n",
       "      <td>-3.705016e+06</td>\n",
       "      <td>0.1000</td>\n",
       "      <td>1.747525e+07</td>\n",
       "      <td>1.068077e+08</td>\n",
       "      <td>600570.XSHG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.148271e+08</td>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>1.242829e+08</td>\n",
       "      <td>6.459525e+08</td>\n",
       "      <td>5.702901e+08</td>\n",
       "      <td>8.904553e+07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         _id  administration_expense  asset_impairment_loss  \\\n",
       "0   5ac57fb02e565406381d089f            1.650519e+07                    NaN   \n",
       "1   5ac57fb02e565406381d08a0            1.350073e+07           0.000000e+00   \n",
       "2   5ac57fb02e565406381d08a1            1.633236e+07           0.000000e+00   \n",
       "3   5ac57fb02e565406381d08a2            3.588122e+07           0.000000e+00   \n",
       "4   5ac57fb02e565406381d08a3            1.118624e+07                    NaN   \n",
       "5   5ac57fb02e565406381d08a4            2.365025e+07           2.546915e+06   \n",
       "6   5ac57fb02e565406381d08a5            1.898346e+07           0.000000e+00   \n",
       "7   5ac57fb02e565406381d08a6            3.815899e+07           6.656682e+06   \n",
       "8   5ac57fb02e565406381d08a7            1.675826e+07                    NaN   \n",
       "9   5ac57fb02e565406381d08a8            2.306086e+07           2.645505e+06   \n",
       "10  5ac57fb02e565406381d08a9            2.969795e+07           3.810000e+04   \n",
       "11  5ac57fb02e565406381d08aa            7.705690e+07           2.057964e+06   \n",
       "12  5ac57fb02e565406381d08ab            3.024180e+07           3.510349e+05   \n",
       "13  5ac57fb02e565406381d08ac            3.006031e+07           1.403876e+06   \n",
       "14  5ac57fb02e565406381d08ad            3.841346e+07           1.764896e+05   \n",
       "15  5ac57fb02e565406381d08ae            1.015926e+08          -1.732956e+06   \n",
       "16  5ac57fb02e565406381d08af            2.597913e+07           1.073165e+06   \n",
       "17  5ac57fb02e565406381d08b0            3.680308e+07           1.913249e+06   \n",
       "18  5ac57fb02e565406381d08b1            4.002534e+07          -3.398468e+05   \n",
       "19  5ac57fb02e565406381d08b2            1.121848e+08           5.899604e+04   \n",
       "20  5ac57fb02e565406381d08b3            4.459986e+07           3.102105e+04   \n",
       "21  5ac57fb02e565406381d08b4            5.693299e+07           3.165044e+06   \n",
       "22  5ac57fb02e565406381d08b5            6.523471e+07          -6.996882e+04   \n",
       "23  5ac57fb02e565406381d08b6            1.592635e+08           9.688032e+05   \n",
       "24  5ac57fb02e565406381d08b7            6.092596e+07           1.847453e+04   \n",
       "25  5ac57fb02e565406381d08b8            8.860041e+07           4.674910e+06   \n",
       "26  5ac57fb02e565406381d08b9            9.171340e+07           6.000000e+03   \n",
       "27  5ac57fb02e565406381d08ba            1.801892e+08           3.616142e+06   \n",
       "28  5ac57fb02e565406381d08bb            8.269467e+07          -4.464517e+05   \n",
       "29  5ac57fb02e565406381d08bc            1.136536e+08           7.355792e+06   \n",
       "30  5ac57fb02e565406381d08bd            1.157561e+08           1.332350e+03   \n",
       "31  5ac57fb02e565406381d08be            1.941328e+08           2.278108e+06   \n",
       "32  5ac57fb02e565406381d08bf            9.848443e+07          -9.510166e+06   \n",
       "33  5ac57fb02e565406381d08c0            1.168314e+08           4.447159e+06   \n",
       "34  5ac57fb02e565406381d08c1            1.226154e+08           0.000000e+00   \n",
       "35  5ac57fb02e565406381d08c2            2.351538e+08          -1.121188e+06   \n",
       "36  5ac57fb02e565406381d08c3            1.257998e+08                    NaN   \n",
       "37  5ac57fb02e565406381d08c4            1.516363e+08           5.117408e+06   \n",
       "38  5ac57fb02e565406381d08c5            1.883604e+08           0.000000e+00   \n",
       "39  5ac57fb02e565406381d08c6            3.352965e+08           7.862399e+04   \n",
       "40  5ac57fb02e565406381d08c7            1.584945e+08                    NaN   \n",
       "41  5ac57fb02e565406381d08c8            2.800698e+08           8.130811e+06   \n",
       "42  5ac57fb02e565406381d08c9            3.721475e+08          -6.018500e+05   \n",
       "43  5ac57fb02e565406381d08ca            2.468927e+08           1.164646e+08   \n",
       "44  5ac57fb02e565406381d08cb            2.026724e+08          -2.479232e+04   \n",
       "45  5ac57fb02e565406381d08cc            2.976088e+08           2.151423e+06   \n",
       "46  5ac57fb02e565406381d08cd            3.298132e+08          -1.092348e+05   \n",
       "47  5ac57fb02e565406381d08ce            5.047452e+08           2.120523e+06   \n",
       "48  5ac57fb02e565406381d08cf            2.971846e+08          -1.289054e+06   \n",
       "49  5ac57fb02e565406381d08d0            3.598160e+08           1.326131e+07   \n",
       "50  5ac57fb02e565406381d08d1            4.150214e+08          -3.705016e+06   \n",
       "\n",
       "    basic_eps  ci_minority_owners  ci_parent_company_owners         code  \\\n",
       "0         NaN                 NaN                       NaN  600570.XSHG   \n",
       "1         NaN        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "2         NaN        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "3         NaN        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "4      0.0191                 NaN                       NaN  600570.XSHG   \n",
       "5      0.0209        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "6      0.0900        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "7      0.1600        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "8      0.0922                 NaN                       NaN  600570.XSHG   \n",
       "9      0.1078        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "10     0.2200        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "11     0.2600        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "12     0.1300                 NaN                       NaN  600570.XSHG   \n",
       "13     0.0300        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "14     0.1100        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "15     0.1800        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "16     0.1100                 NaN                       NaN  600570.XSHG   \n",
       "17     0.0500        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "18     0.1200        0.000000e+00              0.000000e+00  600570.XSHG   \n",
       "19     0.1800        4.360651e+06              2.066964e+08  600570.XSHG   \n",
       "20     0.0800       -1.496884e+06              3.479874e+07  600570.XSHG   \n",
       "21     0.0063        1.576848e+06              4.151714e+06  600570.XSHG   \n",
       "22     0.1072        2.383394e+06              7.635227e+07  600570.XSHG   \n",
       "23     0.1565        5.484606e+05              1.043264e+08  600570.XSHG   \n",
       "24     0.0655       -3.274922e+05              4.070879e+07  600570.XSHG   \n",
       "25     0.0450        3.082941e+06              1.939936e+07  600570.XSHG   \n",
       "26     0.0605       -1.931755e+06              3.853734e+07  600570.XSHG   \n",
       "27     0.2390        5.365554e+06              1.706327e+08  600570.XSHG   \n",
       "28     0.0500        5.112116e+05              1.767486e+07  600570.XSHG   \n",
       "29     0.0400       -4.523277e+05              2.180667e+07  600570.XSHG   \n",
       "30     0.0500        1.847703e+06              4.054506e+07  600570.XSHG   \n",
       "31     0.1800        1.005796e+07              7.868710e+07  600570.XSHG   \n",
       "32     0.0600       -2.325110e+06              6.354569e+07  600570.XSHG   \n",
       "33     0.0700        2.047870e+05              4.849819e+07  600570.XSHG   \n",
       "34     0.0800        3.124965e+05              5.286367e+07  600570.XSHG   \n",
       "35     0.3100        1.793916e+07              1.952787e+08  600570.XSHG   \n",
       "36     0.0900       -2.786795e+06              6.297603e+07  600570.XSHG   \n",
       "37     0.0900       -2.213100e+06              4.176991e+07  600570.XSHG   \n",
       "38     0.0300        2.812352e+06              4.999361e+07  600570.XSHG   \n",
       "39     0.3600       -3.980238e+06              2.183323e+08  600570.XSHG   \n",
       "40     0.1100        1.429527e+06              1.135436e+08  600570.XSHG   \n",
       "41     0.2300        2.183161e+07              1.771184e+08  600570.XSHG   \n",
       "42    -0.0800       -5.895487e+07             -8.562011e+07  600570.XSHG   \n",
       "43     0.4700        3.123601e+07              3.495755e+08  600570.XSHG   \n",
       "44     0.1200       -7.001210e+06              3.477532e+07  600570.XSHG   \n",
       "45     0.1500       -1.178011e+07              1.002529e+08  600570.XSHG   \n",
       "46     0.0700        5.691626e+06              4.382338e+07  600570.XSHG   \n",
       "47    -0.3000       -5.661848e+07             -1.610010e+08  600570.XSHG   \n",
       "48     0.0700       -1.193785e+06              7.429376e+07  600570.XSHG   \n",
       "49     0.3000        5.240964e+06              1.782194e+08  600570.XSHG   \n",
       "50     0.1000        1.747525e+07              1.068077e+08  600570.XSHG   \n",
       "\n",
       "    commission_expense  commission_income  diluted_eps  \\\n",
       "0                  NaN                NaN          NaN   \n",
       "1                  0.0                0.0          NaN   \n",
       "2                  0.0                0.0          NaN   \n",
       "3                  0.0                0.0          NaN   \n",
       "4                  NaN                NaN       0.0137   \n",
       "5                  NaN                NaN       0.0163   \n",
       "6                  NaN                NaN       0.0700   \n",
       "7                  NaN                NaN       0.1900   \n",
       "8                  NaN                NaN       0.0922   \n",
       "9                  NaN                NaN       0.1078   \n",
       "10                 NaN                NaN       0.2200   \n",
       "11                 NaN                NaN       0.2600   \n",
       "12                 NaN                NaN       0.1300   \n",
       "13                 NaN                NaN       0.0300   \n",
       "14                 NaN                NaN       0.1100   \n",
       "15                 NaN                NaN       0.1800   \n",
       "16                 NaN                NaN       0.1100   \n",
       "17                 NaN                NaN       0.0500   \n",
       "18                 NaN                NaN       0.1200   \n",
       "19                 NaN                NaN       0.1800   \n",
       "20                 NaN                NaN       0.0800   \n",
       "21                 NaN                NaN       0.0063   \n",
       "22                 NaN                NaN       0.1072   \n",
       "23                 NaN                NaN       0.1565   \n",
       "24                 NaN                NaN       0.0655   \n",
       "25                 NaN                NaN       0.0450   \n",
       "26                 NaN                NaN       0.0605   \n",
       "27                 NaN                NaN       0.2390   \n",
       "28                 NaN                NaN       0.0500   \n",
       "29                 NaN                NaN       0.0400   \n",
       "30                 NaN                NaN       0.0500   \n",
       "31                 NaN                NaN       0.1800   \n",
       "32                 NaN                NaN       0.0600   \n",
       "33                 NaN                NaN       0.0700   \n",
       "34                 NaN                NaN       0.0800   \n",
       "35                 NaN                NaN       0.3100   \n",
       "36                 NaN                NaN       0.0900   \n",
       "37                 NaN                NaN       0.0900   \n",
       "38                 NaN                NaN       0.0300   \n",
       "39                 NaN                NaN       0.3600   \n",
       "40                 NaN                NaN       0.1100   \n",
       "41                 NaN                NaN       0.2300   \n",
       "42                 NaN                NaN      -0.0800   \n",
       "43                 NaN                NaN       0.4700   \n",
       "44                 NaN                NaN       0.1200   \n",
       "45                 NaN                NaN       0.1500   \n",
       "46                 NaN                NaN       0.0700   \n",
       "47                 NaN                NaN      -0.3000   \n",
       "48                 NaN                NaN       0.0700   \n",
       "49                 NaN                NaN       0.3000   \n",
       "50                 NaN                NaN       0.1000   \n",
       "\n",
       "                   ...                   refunded_premiums  reinsurance_cost  \\\n",
       "0                  ...                                 NaN               NaN   \n",
       "1                  ...                                 0.0               0.0   \n",
       "2                  ...                                 0.0               0.0   \n",
       "3                  ...                                 0.0               0.0   \n",
       "4                  ...                                 NaN               NaN   \n",
       "5                  ...                                 NaN               NaN   \n",
       "6                  ...                                 NaN               NaN   \n",
       "7                  ...                                 NaN               NaN   \n",
       "8                  ...                                 NaN               NaN   \n",
       "9                  ...                                 NaN               NaN   \n",
       "10                 ...                                 NaN               NaN   \n",
       "11                 ...                                 NaN               NaN   \n",
       "12                 ...                                 NaN               NaN   \n",
       "13                 ...                                 NaN               NaN   \n",
       "14                 ...                                 NaN               NaN   \n",
       "15                 ...                                 NaN               NaN   \n",
       "16                 ...                                 NaN               NaN   \n",
       "17                 ...                                 NaN               NaN   \n",
       "18                 ...                                 NaN               NaN   \n",
       "19                 ...                                 NaN               NaN   \n",
       "20                 ...                                 NaN               NaN   \n",
       "21                 ...                                 NaN               NaN   \n",
       "22                 ...                                 NaN               NaN   \n",
       "23                 ...                                 NaN               NaN   \n",
       "24                 ...                                 NaN               NaN   \n",
       "25                 ...                                 NaN               NaN   \n",
       "26                 ...                                 NaN               NaN   \n",
       "27                 ...                                 NaN               NaN   \n",
       "28                 ...                                 NaN               NaN   \n",
       "29                 ...                                 NaN               NaN   \n",
       "30                 ...                                 NaN               NaN   \n",
       "31                 ...                                 NaN               NaN   \n",
       "32                 ...                                 NaN               NaN   \n",
       "33                 ...                                 NaN               NaN   \n",
       "34                 ...                                 NaN               NaN   \n",
       "35                 ...                                 NaN               NaN   \n",
       "36                 ...                                 NaN               NaN   \n",
       "37                 ...                                 NaN               NaN   \n",
       "38                 ...                                 NaN               NaN   \n",
       "39                 ...                                 NaN               NaN   \n",
       "40                 ...                                 NaN               NaN   \n",
       "41                 ...                                 NaN               NaN   \n",
       "42                 ...                                 NaN               NaN   \n",
       "43                 ...                                 NaN               NaN   \n",
       "44                 ...                                 NaN               NaN   \n",
       "45                 ...                                 NaN               NaN   \n",
       "46                 ...                                 NaN               NaN   \n",
       "47                 ...                                 NaN               NaN   \n",
       "48                 ...                                 NaN               NaN   \n",
       "49                 ...                                 NaN               NaN   \n",
       "50                 ...                                 NaN               NaN   \n",
       "\n",
       "    sale_expense    statDate  statDate_1  total_composite_income  \\\n",
       "0   5.326427e+06  2005-03-31  2005-03-31                     NaN   \n",
       "1   9.026373e+06  2005-06-30  2005-06-30            0.000000e+00   \n",
       "2   1.478560e+07  2005-09-30  2005-09-30            0.000000e+00   \n",
       "3   1.260748e+07  2005-12-31  2005-12-31            0.000000e+00   \n",
       "4   1.395958e+07  2006-03-31  2006-03-31                     NaN   \n",
       "5   1.147031e+07  2006-06-30  2006-06-30            0.000000e+00   \n",
       "6   1.548291e+07  2006-09-30  2006-09-30            0.000000e+00   \n",
       "7   1.319190e+07  2006-12-31  2006-12-31            0.000000e+00   \n",
       "8   1.401888e+07  2007-03-31  2007-03-31                     NaN   \n",
       "9   2.458784e+07  2007-06-30  2007-06-30            0.000000e+00   \n",
       "10  3.070183e+07  2007-09-30  2007-09-30            0.000000e+00   \n",
       "11  2.246804e+07  2007-12-31  2007-12-31            0.000000e+00   \n",
       "12  2.163227e+07  2008-03-31  2008-03-31                     NaN   \n",
       "13  2.227069e+07  2008-06-30  2008-06-30            0.000000e+00   \n",
       "14  3.389238e+07  2008-09-30  2008-09-30            0.000000e+00   \n",
       "15  2.590820e+07  2008-12-31  2008-12-31            0.000000e+00   \n",
       "16  2.219355e+07  2009-03-31  2009-03-31                     NaN   \n",
       "17  3.033340e+07  2009-06-30  2009-06-30            0.000000e+00   \n",
       "18  2.711301e+07  2009-09-30  2009-09-30            0.000000e+00   \n",
       "19  5.158045e+07  2009-12-31  2009-12-31            2.110571e+08   \n",
       "20  2.535861e+07  2010-03-31  2010-03-31            3.330186e+07   \n",
       "21  3.531866e+07  2010-06-30  2010-06-30            5.728562e+06   \n",
       "22  3.192449e+07  2010-09-30  2010-09-30            7.873566e+07   \n",
       "23  5.173393e+07  2010-12-31  2010-12-31            1.048749e+08   \n",
       "24  2.878803e+07  2011-03-31  2011-03-31            4.038130e+07   \n",
       "25  3.323484e+07  2011-06-30  2011-06-30            2.248230e+07   \n",
       "26  4.146168e+07  2011-09-30  2011-09-30            3.660559e+07   \n",
       "27  7.084292e+07  2011-12-31  2011-12-31            1.759983e+08   \n",
       "28  3.160459e+07  2012-03-31  2012-03-31            1.818607e+07   \n",
       "29  4.086143e+07  2012-06-30  2012-06-30            2.135434e+07   \n",
       "30  4.373194e+07  2012-09-30  2012-09-30            4.239276e+07   \n",
       "31  7.416365e+07  2012-12-31  2012-12-31            8.874506e+07   \n",
       "32  3.219553e+07  2013-03-31  2013-03-31            6.122058e+07   \n",
       "33  3.393863e+07  2013-06-30  2013-06-30            4.870298e+07   \n",
       "34  4.850965e+07  2013-09-30  2013-09-30            5.317617e+07   \n",
       "35  9.758727e+07  2013-12-31  2013-12-31            2.132179e+08   \n",
       "36  4.733678e+07  2014-03-31  2014-03-31            6.018924e+07   \n",
       "37  6.525140e+07  2014-06-30  2014-06-30            3.955681e+07   \n",
       "38  1.047286e+08  2014-09-30  2014-09-30            5.280596e+07   \n",
       "39  1.401018e+08  2014-12-31  2014-12-31            2.143521e+08   \n",
       "40  8.756997e+07  2015-03-31  2015-03-31            1.149732e+08   \n",
       "41  1.511712e+08  2015-06-30  2015-06-30            1.989500e+08   \n",
       "42  1.667889e+08  2015-09-30  2015-09-30           -1.445750e+08   \n",
       "43  1.762892e+08  2015-12-31  2015-12-31            3.808116e+08   \n",
       "44  1.163337e+08  2016-03-31  2016-03-31            2.777411e+07   \n",
       "45  1.279108e+08  2016-06-30  2016-06-30            8.847283e+07   \n",
       "46  2.008967e+08  2016-09-30  2016-09-30            4.951500e+07   \n",
       "47  2.178740e+08  2016-12-31  2016-12-31           -2.176195e+08   \n",
       "48  1.580180e+08  2017-03-31  2017-03-31            7.309998e+07   \n",
       "49  1.869998e+08  2017-06-30  2017-06-30            1.834603e+08   \n",
       "50  2.148271e+08  2017-09-30  2017-09-30            1.242829e+08   \n",
       "\n",
       "    total_operating_cost  total_operating_revenue  total_profit  \\\n",
       "0           4.169257e+07             3.861545e+07  2.471650e+05   \n",
       "1           4.834777e+07             4.962814e+07  2.502735e+06   \n",
       "2           5.395177e+07             4.878073e+07 -1.067038e+06   \n",
       "3           9.805474e+07             9.971500e+07  6.309092e+06   \n",
       "4           5.949652e+07             5.551059e+07  1.853099e+06   \n",
       "5           8.285141e+07             8.146291e+07  4.676409e+06   \n",
       "6           6.755671e+07             7.771690e+07  1.415241e+07   \n",
       "7           1.306259e+08             1.311665e+08  4.150465e+07   \n",
       "8           5.596684e+07             5.925009e+07  1.602855e+07   \n",
       "9           1.200182e+08             1.255172e+08  2.988806e+07   \n",
       "10          1.322278e+08             1.561338e+08  4.894864e+07   \n",
       "11          2.067672e+08             2.315271e+08  4.705567e+07   \n",
       "12          1.245168e+08             1.495216e+08  2.801362e+07   \n",
       "13          9.731574e+07             1.115232e+08  7.551398e+06   \n",
       "14          1.168202e+08             1.430293e+08  3.502918e+07   \n",
       "15          2.188555e+08             2.646075e+08  6.589000e+07   \n",
       "16          1.012803e+08             1.195908e+08  3.628342e+07   \n",
       "17          9.680222e+07             1.298877e+08  4.342704e+07   \n",
       "18          1.142544e+08             1.570479e+08  5.920321e+07   \n",
       "19          2.692821e+08             3.231854e+08  9.376719e+07   \n",
       "20          8.620820e+07             1.079588e+08  3.632138e+07   \n",
       "21          1.663644e+08             1.868096e+08  2.387972e+07   \n",
       "22          1.568459e+08             2.151671e+08  7.504538e+07   \n",
       "23          3.096945e+08             3.572915e+08  1.084017e+08   \n",
       "24          1.281578e+08             1.596664e+08  4.334764e+07   \n",
       "25          1.951570e+08             2.100290e+08  3.541586e+07   \n",
       "26          1.645998e+08             1.878616e+08  3.582275e+07   \n",
       "27          3.706134e+08             4.906363e+08  1.712592e+08   \n",
       "28          1.354821e+08             1.422648e+08  3.418722e+07   \n",
       "29          2.097509e+08             2.156263e+08  3.390782e+07   \n",
       "30          1.992396e+08             1.961722e+08  2.989635e+07   \n",
       "31          4.068516e+08             4.520283e+08  1.232218e+08   \n",
       "32          1.498439e+08             1.719325e+08  4.043195e+07   \n",
       "33          2.283300e+08             2.493508e+08  4.934582e+07   \n",
       "34          2.002277e+08             2.244718e+08  7.485840e+07   \n",
       "35          4.482614e+08             5.647921e+08  2.035822e+08   \n",
       "36          1.884408e+08             2.017034e+08  5.921796e+07   \n",
       "37          2.521245e+08             2.609672e+08  5.877667e+07   \n",
       "38          3.189146e+08             3.082180e+08  5.096428e+07   \n",
       "39          5.050815e+08             6.509505e+08  2.171650e+08   \n",
       "40          2.648900e+08             2.741318e+08  7.809997e+07   \n",
       "41          5.242981e+08             6.342701e+08  1.753289e+08   \n",
       "42          5.540822e+08             3.899162e+08 -1.033324e+08   \n",
       "43          6.161181e+08             9.272142e+08  3.650838e+08   \n",
       "44          3.293775e+08             3.369861e+08  7.014102e+07   \n",
       "45          4.608934e+08             4.835933e+08  8.928306e+07   \n",
       "46          5.665901e+08             5.168427e+08  2.343213e+07   \n",
       "47          7.849189e+08             8.327441e+08 -2.428427e+08   \n",
       "48          4.778144e+08             4.428547e+08  4.108078e+07   \n",
       "49          5.923973e+08             6.374332e+08  2.054813e+08   \n",
       "50          6.459525e+08             5.702901e+08  8.904553e+07   \n",
       "\n",
       "    withdraw_insurance_contract_reserve  \n",
       "0                                   NaN  \n",
       "1                                   0.0  \n",
       "2                                   0.0  \n",
       "3                                   0.0  \n",
       "4                                   NaN  \n",
       "5                                   NaN  \n",
       "6                                   NaN  \n",
       "7                                   NaN  \n",
       "8                                   NaN  \n",
       "9                                   NaN  \n",
       "10                                  NaN  \n",
       "11                                  NaN  \n",
       "12                                  NaN  \n",
       "13                                  NaN  \n",
       "14                                  NaN  \n",
       "15                                  NaN  \n",
       "16                                  NaN  \n",
       "17                                  NaN  \n",
       "18                                  NaN  \n",
       "19                                  NaN  \n",
       "20                                  NaN  \n",
       "21                                  NaN  \n",
       "22                                  NaN  \n",
       "23                                  NaN  \n",
       "24                                  NaN  \n",
       "25                                  NaN  \n",
       "26                                  NaN  \n",
       "27                                  NaN  \n",
       "28                                  NaN  \n",
       "29                                  NaN  \n",
       "30                                  NaN  \n",
       "31                                  NaN  \n",
       "32                                  NaN  \n",
       "33                                  NaN  \n",
       "34                                  NaN  \n",
       "35                                  NaN  \n",
       "36                                  NaN  \n",
       "37                                  NaN  \n",
       "38                                  NaN  \n",
       "39                                  NaN  \n",
       "40                                  NaN  \n",
       "41                                  NaN  \n",
       "42                                  NaN  \n",
       "43                                  NaN  \n",
       "44                                  NaN  \n",
       "45                                  NaN  \n",
       "46                                  NaN  \n",
       "47                                  NaN  \n",
       "48                                  NaN  \n",
       "49                                  NaN  \n",
       "50                                  NaN  \n",
       "\n",
       "[51 rows x 43 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df['pubDate'] = pd.to_datetime(df['pubDate'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "incomedf = df[df.pubDate <= '2017-06-06'][-4:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "column_sum = incomedf['net_profit'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"c:\\\\stockdata\\\\guben\\\\600570.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>circulation_a</th>\n",
       "      <th>management_circulation</th>\n",
       "      <th>non_circulation_a</th>\n",
       "      <th>total_a</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2003-12-16</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2003-12-17</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2003-12-18</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2003-12-19</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2003-12-22</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2003-12-23</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2003-12-24</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2003-12-25</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2003-12-26</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2003-12-29</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2003-12-30</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2003-12-31</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2004-01-02</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2004-01-05</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2004-01-06</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2004-01-07</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2004-01-08</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2004-01-09</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2004-01-12</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2004-01-13</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2004-01-14</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2004-01-15</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2004-01-16</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2004-01-29</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2004-01-30</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2004-02-02</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2004-02-03</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2004-02-04</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2004-02-05</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2004-02-06</td>\n",
       "      <td>17000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "      <td>68000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3433</th>\n",
       "      <td>2018-01-29</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3434</th>\n",
       "      <td>2018-01-30</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3435</th>\n",
       "      <td>2018-01-31</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3436</th>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3437</th>\n",
       "      <td>2018-02-02</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3438</th>\n",
       "      <td>2018-02-05</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3439</th>\n",
       "      <td>2018-02-06</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3440</th>\n",
       "      <td>2018-02-07</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3441</th>\n",
       "      <td>2018-02-08</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3442</th>\n",
       "      <td>2018-02-09</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3443</th>\n",
       "      <td>2018-02-12</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3444</th>\n",
       "      <td>2018-02-13</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3445</th>\n",
       "      <td>2018-02-14</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3446</th>\n",
       "      <td>2018-02-22</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3447</th>\n",
       "      <td>2018-02-23</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3448</th>\n",
       "      <td>2018-02-26</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3449</th>\n",
       "      <td>2018-02-27</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3450</th>\n",
       "      <td>2018-02-28</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3451</th>\n",
       "      <td>2018-03-01</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3452</th>\n",
       "      <td>2018-03-02</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3453</th>\n",
       "      <td>2018-03-05</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3454</th>\n",
       "      <td>2018-03-06</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3455</th>\n",
       "      <td>2018-03-07</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3456</th>\n",
       "      <td>2018-03-08</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3457</th>\n",
       "      <td>2018-03-09</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3458</th>\n",
       "      <td>2018-03-12</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3459</th>\n",
       "      <td>2018-03-13</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3460</th>\n",
       "      <td>2018-03-14</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3461</th>\n",
       "      <td>2018-03-15</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3462</th>\n",
       "      <td>2018-03-16</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>617805180.0</td>\n",
       "      <td>617805180.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3463 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            date  circulation_a  management_circulation  non_circulation_a  \\\n",
       "0     2003-12-16     17000000.0                     NaN         51000000.0   \n",
       "1     2003-12-17     17000000.0                     NaN         51000000.0   \n",
       "2     2003-12-18     17000000.0                     NaN         51000000.0   \n",
       "3     2003-12-19     17000000.0                     NaN         51000000.0   \n",
       "4     2003-12-22     17000000.0                     NaN         51000000.0   \n",
       "5     2003-12-23     17000000.0                     NaN         51000000.0   \n",
       "6     2003-12-24     17000000.0                     NaN         51000000.0   \n",
       "7     2003-12-25     17000000.0                     NaN         51000000.0   \n",
       "8     2003-12-26     17000000.0                     NaN         51000000.0   \n",
       "9     2003-12-29     17000000.0                     NaN         51000000.0   \n",
       "10    2003-12-30     17000000.0                     NaN         51000000.0   \n",
       "11    2003-12-31     17000000.0                     NaN         51000000.0   \n",
       "12    2004-01-02     17000000.0                     NaN         51000000.0   \n",
       "13    2004-01-05     17000000.0                     NaN         51000000.0   \n",
       "14    2004-01-06     17000000.0                     NaN         51000000.0   \n",
       "15    2004-01-07     17000000.0                     NaN         51000000.0   \n",
       "16    2004-01-08     17000000.0                     NaN         51000000.0   \n",
       "17    2004-01-09     17000000.0                     NaN         51000000.0   \n",
       "18    2004-01-12     17000000.0                     NaN         51000000.0   \n",
       "19    2004-01-13     17000000.0                     NaN         51000000.0   \n",
       "20    2004-01-14     17000000.0                     NaN         51000000.0   \n",
       "21    2004-01-15     17000000.0                     NaN         51000000.0   \n",
       "22    2004-01-16     17000000.0                     NaN         51000000.0   \n",
       "23    2004-01-29     17000000.0                     NaN         51000000.0   \n",
       "24    2004-01-30     17000000.0                     NaN         51000000.0   \n",
       "25    2004-02-02     17000000.0                     NaN         51000000.0   \n",
       "26    2004-02-03     17000000.0                     NaN         51000000.0   \n",
       "27    2004-02-04     17000000.0                     NaN         51000000.0   \n",
       "28    2004-02-05     17000000.0                     NaN         51000000.0   \n",
       "29    2004-02-06     17000000.0                     NaN         51000000.0   \n",
       "...          ...            ...                     ...                ...   \n",
       "3433  2018-01-29    617805180.0                     NaN                0.0   \n",
       "3434  2018-01-30    617805180.0                     NaN                0.0   \n",
       "3435  2018-01-31    617805180.0                     NaN                0.0   \n",
       "3436  2018-02-01    617805180.0                     NaN                0.0   \n",
       "3437  2018-02-02    617805180.0                     NaN                0.0   \n",
       "3438  2018-02-05    617805180.0                     NaN                0.0   \n",
       "3439  2018-02-06    617805180.0                     NaN                0.0   \n",
       "3440  2018-02-07    617805180.0                     NaN                0.0   \n",
       "3441  2018-02-08    617805180.0                     NaN                0.0   \n",
       "3442  2018-02-09    617805180.0                     NaN                0.0   \n",
       "3443  2018-02-12    617805180.0                     NaN                0.0   \n",
       "3444  2018-02-13    617805180.0                     NaN                0.0   \n",
       "3445  2018-02-14    617805180.0                     NaN                0.0   \n",
       "3446  2018-02-22    617805180.0                     NaN                0.0   \n",
       "3447  2018-02-23    617805180.0                     NaN                0.0   \n",
       "3448  2018-02-26    617805180.0                     NaN                0.0   \n",
       "3449  2018-02-27    617805180.0                     NaN                0.0   \n",
       "3450  2018-02-28    617805180.0                     NaN                0.0   \n",
       "3451  2018-03-01    617805180.0                     NaN                0.0   \n",
       "3452  2018-03-02    617805180.0                     NaN                0.0   \n",
       "3453  2018-03-05    617805180.0                     NaN                0.0   \n",
       "3454  2018-03-06    617805180.0                     NaN                0.0   \n",
       "3455  2018-03-07    617805180.0                     NaN                0.0   \n",
       "3456  2018-03-08    617805180.0                     NaN                0.0   \n",
       "3457  2018-03-09    617805180.0                     NaN                0.0   \n",
       "3458  2018-03-12    617805180.0                     NaN                0.0   \n",
       "3459  2018-03-13    617805180.0                     NaN                0.0   \n",
       "3460  2018-03-14    617805180.0                     NaN                0.0   \n",
       "3461  2018-03-15    617805180.0                     NaN                0.0   \n",
       "3462  2018-03-16    617805180.0                     NaN                0.0   \n",
       "\n",
       "          total_a        total  \n",
       "0      68000000.0   68000000.0  \n",
       "1      68000000.0   68000000.0  \n",
       "2      68000000.0   68000000.0  \n",
       "3      68000000.0   68000000.0  \n",
       "4      68000000.0   68000000.0  \n",
       "5      68000000.0   68000000.0  \n",
       "6      68000000.0   68000000.0  \n",
       "7      68000000.0   68000000.0  \n",
       "8      68000000.0   68000000.0  \n",
       "9      68000000.0   68000000.0  \n",
       "10     68000000.0   68000000.0  \n",
       "11     68000000.0   68000000.0  \n",
       "12     68000000.0   68000000.0  \n",
       "13     68000000.0   68000000.0  \n",
       "14     68000000.0   68000000.0  \n",
       "15     68000000.0   68000000.0  \n",
       "16     68000000.0   68000000.0  \n",
       "17     68000000.0   68000000.0  \n",
       "18     68000000.0   68000000.0  \n",
       "19     68000000.0   68000000.0  \n",
       "20     68000000.0   68000000.0  \n",
       "21     68000000.0   68000000.0  \n",
       "22     68000000.0   68000000.0  \n",
       "23     68000000.0   68000000.0  \n",
       "24     68000000.0   68000000.0  \n",
       "25     68000000.0   68000000.0  \n",
       "26     68000000.0   68000000.0  \n",
       "27     68000000.0   68000000.0  \n",
       "28     68000000.0   68000000.0  \n",
       "29     68000000.0   68000000.0  \n",
       "...           ...          ...  \n",
       "3433  617805180.0  617805180.0  \n",
       "3434  617805180.0  617805180.0  \n",
       "3435  617805180.0  617805180.0  \n",
       "3436  617805180.0  617805180.0  \n",
       "3437  617805180.0  617805180.0  \n",
       "3438  617805180.0  617805180.0  \n",
       "3439  617805180.0  617805180.0  \n",
       "3440  617805180.0  617805180.0  \n",
       "3441  617805180.0  617805180.0  \n",
       "3442  617805180.0  617805180.0  \n",
       "3443  617805180.0  617805180.0  \n",
       "3444  617805180.0  617805180.0  \n",
       "3445  617805180.0  617805180.0  \n",
       "3446  617805180.0  617805180.0  \n",
       "3447  617805180.0  617805180.0  \n",
       "3448  617805180.0  617805180.0  \n",
       "3449  617805180.0  617805180.0  \n",
       "3450  617805180.0  617805180.0  \n",
       "3451  617805180.0  617805180.0  \n",
       "3452  617805180.0  617805180.0  \n",
       "3453  617805180.0  617805180.0  \n",
       "3454  617805180.0  617805180.0  \n",
       "3455  617805180.0  617805180.0  \n",
       "3456  617805180.0  617805180.0  \n",
       "3457  617805180.0  617805180.0  \n",
       "3458  617805180.0  617805180.0  \n",
       "3459  617805180.0  617805180.0  \n",
       "3460  617805180.0  617805180.0  \n",
       "3461  617805180.0  617805180.0  \n",
       "3462  617805180.0  617805180.0  \n",
       "\n",
       "[3463 rows x 6 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.rename(columns={'Unnamed: 0':'date'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
